package com.web.server.common.export;

/**
 * Created by ZHANGXIANLIANG1 on 2016-05-13.
 */
public class ExcelTemplate {
    public static final String EXCEL_TEMPLATE_HEAD = "" +
            "<?xml version='1.0'?>" +
            "<?mso-application progid='Excel.Sheet'?>" +
            "<Workbook xmlns='urn:schemas-microsoft-com:office:spreadsheet'" +
            " xmlns:o='urn:schemas-microsoft-com:office:office'" +
            " xmlns:x='urn:schemas-microsoft-com:office:excel'" +
            " xmlns:ss='urn:schemas-microsoft-com:office:spreadsheet'" +
            " xmlns:html='http://www.w3.org/TR/REC-html40'>" +
            " <DocumentProperties xmlns='urn:schemas-microsoft-com:office:office'>" +
            "  <Version>16.00</Version>" +
            " </DocumentProperties>" +
            " <ExcelWorkbook xmlns='urn:schemas-microsoft-com:office:excel'>" +
            "  <ProtectStructure>False</ProtectStructure>" +
            "  <ProtectWindows>False</ProtectWindows>" +
            " </ExcelWorkbook>";

    public static final String EXCEL_TEMPLATE_TAIL = "</Workbook>";

    public static final String WORK_SHEET_HEAD = "" +
            " <Worksheet ss:Name='{SheetName}'>" +
            "  <Table ss:DefaultColumnWidth='54' ss:DefaultRowHeight='14.25'>";

    public static final String WORK_SHEET_TAIL = "" +
            "  </Table>" +
            "  <WorksheetOptions xmlns='urn:schemas-microsoft-com:office:excel'>" +
            "   <ProtectObjects>False</ProtectObjects>" +
            "   <ProtectScenarios>False</ProtectScenarios>" +
            "  </WorksheetOptions>" +
            " </Worksheet>";
}
